UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IIm+HsrALCKzvz8TY93GK7teKfdM/guGHON8zMwswA0='
WHERE
key_id = '47e77ee9044e4fcce87b87af43bd4834f799f7f62bb3991ebc9b3b2d9019cc88'
AND (
token = 'IIm+HsrALCKzvz8TY93GK7teKfdM/guGHON8zMwswA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)