UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aGYvjmEeOSF0uAwphBOuzNHOr+Ivjr8jzuTYiG52Emc='
WHERE
key_id = 'bda41a4a07878ffeca18343a23c77a8f554152eb5d4433ad6f0c5ba8f0b9b26f'
AND (
token = 'aGYvjmEeOSF0uAwphBOuzNHOr+Ivjr8jzuTYiG52Emc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)