There is no reliable way to achieve what you want with the Transients API – or even, if you have been considering it, with the WP Cron system. The problem is in a nutshell: Those API systems depend on user input. If you want to know more about it, do a research, as this has been discussed a couple of times.
To have a reliable solution, you can use the real – the WP one has pretty much nothing to do with it and in my mind it shouldn’t even be called alike, but whatever – CRON system and the cronjobs you can set up with it. I’m not going into depth here, because you will find enough starting information about »How the real CRON can be used with WordPress« on the internet. As @MarkKaplun rightfully pointed out, WP CRON and real CRON can be used in conjunction to achieve your goal.
