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