UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bkd+ra3miEGJVaqYxK50cFgcSTFT8aaFLRSmiWpwYHo='
WHERE
key_id = '1d04324ea194d5afd58c36997bac754b13714021f533238f0bb6dd26f6d09df5'
AND (
token = 'Bkd+ra3miEGJVaqYxK50cFgcSTFT8aaFLRSmiWpwYHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)