UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k1knXgS9DgIYHR1nLtCjg8w4V7n58IO2FtXcQJxYrW4='
WHERE
key_id = '4f1f37d459250ef826cd878a7749ab512fccfbc49b3e344ec266238256a57260'
AND (
token = 'k1knXgS9DgIYHR1nLtCjg8w4V7n58IO2FtXcQJxYrW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)