UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6OQXo9dvCHMYb2qmSu8TXT3iL0tkLMe9fgU10PSEzq8='
WHERE
key_id = 'df9a8eccb5847e834e524770a861b85505f261a7f87d1e965b70d5a046d33ab9'
AND (
token = '6OQXo9dvCHMYb2qmSu8TXT3iL0tkLMe9fgU10PSEzq8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)