How do I synchronize rows in tables in remote databases?
If the GUID is the absolute truth about what is supposed to match, then the GUID must be the PRIMARY KEY.  Get rid of id.

If you want semi-automated "conflict resolution based on time", you want MySQL's NDB Cluster.