UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fzMq7TnUzH6opiwDiRKilKlyD37eHHBlfnbajQUJPxU='
WHERE
key_id = 'c7e49e602f758953f6bef695a3fb355f37f9f3e8f2ec7fbef8b0a86a8d36663e'
AND (
token = 'fzMq7TnUzH6opiwDiRKilKlyD37eHHBlfnbajQUJPxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)