UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zmv5pLLLUukDYduf+vrLLmu/LXZCRLpsk6CprBVvNmY='
WHERE
key_id = 'e23b87ac9c9e4f6305a16e3e89f5b2ca9a8ed2f63c5140ac4f640fa16718960f'
AND (
token = 'zmv5pLLLUukDYduf+vrLLmu/LXZCRLpsk6CprBVvNmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)