For the last 3 days, I have had the same alert trigger email saying that something is expiring within x days.
As I was writing this request, I was thinking of a more or less condition, but, I think all we actually need is a "once on x days"
This would allow a very early warning on 60 days.
A more casual warning on 30 days as a one off.
A "you need to act now" 15 days as a one off.
Then (as now) a daily nag if less than 7.