UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I1a7mzE3V4i2A+hyIVn9DB0HZ3uSIuSAy9NZvp3IPRw='
WHERE
key_id = '360774d202b2d7f168b73e18e9b622c610c45ebc5e3e313424bd5e88e33d1a94'
AND (
token = 'I1a7mzE3V4i2A+hyIVn9DB0HZ3uSIuSAy9NZvp3IPRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)