UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mVPFz/JnNQWO92JjSuNy5I1Fb1HpTG6Mju7VlMhsUAc='
WHERE
key_id = '49a6ffa2c7b95887e3c7045b92021c83e448a806e09a835336f583a9d524668a'
AND (
token = 'mVPFz/JnNQWO92JjSuNy5I1Fb1HpTG6Mju7VlMhsUAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)