Standard timezone antidote is to do everything in UTC ;-)

Of course, it's probably a bit late to do that for you. So the next best thing may be to try to set a TZ environment variable, but if you're sharing a mysql server with others, you probably won't be able to control it. So then you're probably stuck at tuning everything for 4 hours off. If you're looking at all the code anyway, it may pay off to just convert it all to gmtime instead of localtime anyway.