UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm4oodQWw6O8QiVwPNouSI5h7gS9Ua83pcW8+imqBnkg='
WHERE
key_id = 'bfccab3fab97c8d6950661b284d30018934341bc5d40b273c2ef591eb9d67603'
AND (
token = 'm4oodQWw6O8QiVwPNouSI5h7gS9Ua83pcW8+imqBnkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)