UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HgberGB0dTNr4qyaG8riFlvkKssjzg20KiXiDizDKW4='
WHERE
key_id = '80442bfc43fc1b6ef25afed28a765774522227ac37a24defef60c08fa51e9e74'
AND (
token = 'HgberGB0dTNr4qyaG8riFlvkKssjzg20KiXiDizDKW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)