UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mB9diweISQ2+kgjS4n1sZni16fGJLSfmP03mJ9J2+rc='
WHERE
key_id = '8ac1b8646a9e1ac51792572b9245029ffdb34f96cd3805c50e518c558bde827f'
AND (
token = 'mB9diweISQ2+kgjS4n1sZni16fGJLSfmP03mJ9J2+rc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)