MySQL timestamp record being updated but affected rows remains 0
For those curious I resorted to using an INSERT INTO... ON DUPLICATE KEY UPDATE to achieve the desired result. I still couldn't figure out why MySQL wasn't reporting the record as being affected.
I also tried using PHPs mysql_query() and related functions to check the affected row but it didn't work like that also. Perhaps MySQL doesn't deem the change to be worthy of marking the record as affected.