UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dxe47UHQP8b2rdNf+8QzuPhbXVlM9ENUhaJxrk97qmo='
WHERE
key_id = '49d5e61b6072477a8f7188e7f44cdb9cb2f4e17aca08007a63ca60554e3e4cc4'
AND (
token = 'dxe47UHQP8b2rdNf+8QzuPhbXVlM9ENUhaJxrk97qmo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)