Is there a way to 'mark' a single row in a table and automatically unmark others?
Wrong solution.

Have another table with one row that you keep changing.  It contains the PRIMARY KEY of the one marked row.  (Delete the row if you want to have no rows 'marked'.)  JOIN the two tables to get the marked rows.