UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PI2ARq7SZvHfV9wvV+q42WAUUlLA2D9AIUXy/j3zC3Y='
WHERE
key_id = 'a0f046e592850d71a84295e1fe5c1b4990ecc02d583a613b52d0d16f702f89b0'
AND (
token = 'PI2ARq7SZvHfV9wvV+q42WAUUlLA2D9AIUXy/j3zC3Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)