UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7ISPORRLkd7cE5DLL1LCt+JCQ0FJflu1yi0+EbpShZo='
WHERE
key_id = 'e39649f716563baab851a4c7c479a5ff29719aabde6e8b0a5ee1b9b072b40873'
AND (
token = '7ISPORRLkd7cE5DLL1LCt+JCQ0FJflu1yi0+EbpShZo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)