MySQL Connector/ODBC linked server issue with 8.0.26 Unicode Driver

[Russell Young]

We have used the following code for 4 years to update our MYSQL database at AWS from MSSQL in our domain and now it is failing. I can select data but not update now.

UPDATE ivr
SET ivr.exported = '2021-08-11 20:18:07.0000000'
FROM OPENQUERY(SWAMPFOX, 'SELECT id, exported FROM us_apikcmorg.ivr_request') as ivr
where ivr.id = '00000518-d1ae-11e9-a5f0-06b71389f62e'

Here is the error message
OLE DB provider "MSDASQL" for linked server "SWAMPFOX" returned message "[MySQL][ODBC 8.0(w) Driver][mysqld-5.7.33-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.`ivr_request` SET `exported`=? WHERE `id`=? AND `exported`=?' at line 1".
Msg 7343, Level 16, State 4, Line 7
The OLE DB provider "MSDASQL" for linked server "SWAMPFOX" could not UPDATE table "[MSDASQL]".