UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YSZUeJyYnb3vCjsnbv1YW8yPAn8fTz+hq9R647UYwL0='
WHERE
key_id = '99fab0b2e00514ac94e45c41294e7b04637c11e20ec4e086f7a8b0e922e6a450'
AND (
token = 'YSZUeJyYnb3vCjsnbv1YW8yPAn8fTz+hq9R647UYwL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)