Is there any way to set time that CURRENT_TIMESTAMP and/or now() will give next time? (We need it only for testing purposes so if there is any hack, cheat, etc. It will be fine)
This is a bad way - don't use now() in queries - use a variable instead. Later you can use now as an argument or some constant value.