UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gej7n1Kv+xxWxKhDOaYwn1ttVjLrBwh71k044lJxXN4='
WHERE
key_id = '49707652ebc3e4aaa7e7b9b30658367e55df7e405c693c5a4f4d02f8dbe27cd3'
AND (
token = 'Gej7n1Kv+xxWxKhDOaYwn1ttVjLrBwh71k044lJxXN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)