Update lapsed community subscriptions for billing before renewals lapse

Your canceled subscription records from the community land unsynced, causing billing discrepancies and missed churn reporting. Keep billing and subscription tables accurate so revenue ops can reconcile before the next billing run.