UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7sNsIbbgp3Oe8Ja+MyX7EqwQkOfVKzhSeiCoXWo24iU='
WHERE
key_id = '9c807af5364c63979d89f70beeaabb81a413dd4defbfa6abd3c61234497f2953'
AND (
token = '7sNsIbbgp3Oe8Ja+MyX7EqwQkOfVKzhSeiCoXWo24iU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)