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