UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qR1qne3AupPdEH0ezbbV5HQOk2/5kNAAPn/rstlY6YU='
WHERE
key_id = 'cccc9a6b9f71bc99495c39785bfea8a4b75555ef5005c9a80687c149671633b7'
AND (
token = 'qR1qne3AupPdEH0ezbbV5HQOk2/5kNAAPn/rstlY6YU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)