Add "equals 7 days from today" to the Membership expiration date criteria in query
Adding this option to query would make it easy to set up auto reminders in Marketing & Communications: Reminders, to keep in compliance with the new Mastercard is implementing on 9/22/22