The person who asked the question can change their mind about the accepted answer at any time by clicking the check mark again, or clicking the check mark next to another answer.
Moderators cannot override this, though obviously anybody with sufficient access to the database probably could...and almost certainly won't.
