Live Database Sync. MySQL - SQL Server
You can use Linked Server for SQL Server side. Creata a stored procedure to check online mysql tables data. If product sold decrease the local product count on the Local SQL Server.

Why do you cover this problem on the application side using transaction ?