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

  WHERE COL_B is '01:00:00'