UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'htBdtywf1WF9J8qGdtIq13OT3n7OamBOe+uPJNoJjdk='
WHERE
key_id = 'fbe3051d43bcfdf2b97f236a01662d9e2b0d6f3fb97c8317d449c4dd073cce3a'
AND (
token = 'htBdtywf1WF9J8qGdtIq13OT3n7OamBOe+uPJNoJjdk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)