UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ys0mz8WlAVAWQ1S3sOIedQud68afjhmbiouZCVNP8Pg='
WHERE
key_id = 'ae140f2540d27d51508bbe7262dc311bf97700de9b26c29821e9641064f64624'
AND (
token = 'Ys0mz8WlAVAWQ1S3sOIedQud68afjhmbiouZCVNP8Pg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)