INSERT INTO FOO 
  .... 
  ON DUPLICATE KEY UPDATE
  FOO.COL_A = NOW() + FOO.COL_B 

/*   WHERE COL_B is '01:00:00'

...... and randomly a number of columns are beign set to 0000-00-00 00:00:00 

... which seems like a bug.

 */