30 minute timer that has normally closed circuit. It goes off when timer activated
Ignoring as off-topic the question of "find a part that works this way directly" I'll address the on-topic question of "how to do this with the usual timer that's on for 30-60 minutes and then goes off"

Which is: connect the timer to the coil of a normally closed relay connected between the light and the motion sensor (or ahead of the motion sensor if the light and sensor are combined.)