UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CsOoZtq8az9Z+2GoamfvT2UjbYv6bUnTigtoXpUAlSc='
WHERE
key_id = '8a40687e0f5602950f659d55cc956cc42d32ef1f09fa995ba122c82707029148'
AND (
token = 'CsOoZtq8az9Z+2GoamfvT2UjbYv6bUnTigtoXpUAlSc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)