UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EQC9npi45AwB802AYbwSRdSeUjJluP3TgDzV21gICPs='
WHERE
key_id = '8e12d6e782262bee14516dc947e1fd996ee1ba47e916c9f5c0953303dd5fecad'
AND (
token = 'EQC9npi45AwB802AYbwSRdSeUjJluP3TgDzV21gICPs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)