But then I realised that MySQL server was not using the updated time, why was that???
Well, remember, that if you would like the change in linux time to affect MySQL server, you have to restart MySQL server
service mysql restart
and then it will use the same time as the linux server.