UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gh3inW+W7ibY1NGW1ZYXQODpHOXGIeIfDUYKg8GGDU0='
WHERE
key_id = 'f80a3040dac12cb304294927a41174b6bad3b0c80fdef6e20fff2a7640020227'
AND (
token = 'gh3inW+W7ibY1NGW1ZYXQODpHOXGIeIfDUYKg8GGDU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)