UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'thqrxPRI1h4ZNlpBw7OYHKPkq2/iC7txuRsrk8JttvU='
WHERE
key_id = 'a0c815083f53c06862dd332fe67bb7f7e9c74eac8ea06615fc1399b84eb13ec5'
AND (
token = 'thqrxPRI1h4ZNlpBw7OYHKPkq2/iC7txuRsrk8JttvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)