Improve AggregateLast30DayUsageService execute method performance

The current implementation takes 20mins-1h to finish the cron job. There might be some space of improvement around the SQL query that gets generated via AggregateLast30DayUsageService execute method.

We need to ensure this never runs over 5 minutes so it doesn't eat into our error budget.

Validation: After a week of the fix being implemented, verify the duration of the job in kibana to check if the duration have dropped.