I feel like this defeates the purpose of the Affliate Coupon. They are designed to be used in YouTube videos and other content that will live forever and be watched months or years later. It would be similar to the idea of "have the affiliate referral link expire" or "have temporary affiliate campaigns".

However, I think you can achieve the goal you are looking for thanks to some recent enhancements. You can create a coupon code in the coupon area that does expire and you can setup an automation that when a specific coupon code is used it gives attribution to a specific affiliate in a specific campaign.

I've done this exact thing recently and it works really well, the only down side is the additional steps to do this if you have a large amount of affiliates.