I’m assuming the table has a primary key. First try to run a unlock tables command to see if that fixes it.
If all else fails you can alter the table to create a new primary key column with auto-increment and that should hopefully fix it. Once you’re done you should be able to remove the column without any issues.
As always you want to make a backup before altering tables around. 🙂
Note: MySQL workbench cannot work without a primary key if that’s your issue. However if you have a many to many table you can set both columns as primary keys which will let you edit the data.