cursor = cnxn.cursor()
cursor.execute(
    'UPDATE progress SET CockpitDrill = ? WHERE progress_primarykey = ?',
    newcockpitdrillvalue, oldprimarykeyvalue)
cnxn.commit()
SQL Update statement but using pyodbc