I would buy a 24 hour timer used for switching lights on at night.
They can be set to turn on every hour.
This can switch on a 9v power supply which activates a 555 timer.
The 555 can be programmed (with 2 resistors and a capacitor) to switch on for 30 seconds - activating a relay, which switches on your motor which is driven from the same 9v power supply.