UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XEmoirZq94rtLasu8OovwDEANenZqK9H1hQdexSHbko='
WHERE
key_id = '31da1970db051e6a987513df30bf227e4151d6bfef9f085ab83929b78ccb122c'
AND (
token = 'XEmoirZq94rtLasu8OovwDEANenZqK9H1hQdexSHbko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)