UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LPzzuXVuY8SBKVe2hcd7CUv0KVJOIB5f93IBW63pYU4='
WHERE
key_id = '87229370f340932a95cd99ab009504dc17a4ee1588e25b3c8f2df5cbb172c17e'
AND (
token = 'LPzzuXVuY8SBKVe2hcd7CUv0KVJOIB5f93IBW63pYU4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)