BACKUP your Library before attempting
Bulk mode Search & Replace (S&R)
might be the solution
Select all (or a few to test) bad books: Tap the 'E' (edit metadata Bulk mode):
Switch to the S&R tab: Regular Expression mode, replace field
Search field: Identifiers (form adjusts for context)
Identifier type: isbn: Search for: 9780062453006\s*(\d+)
Replace with: \1
Validate that the test samples (right) look sane
The theory (plan

)
Looks for ISBN starting with 9780062453006 (optional space) and captures the remaining digits.
The replace sets the ISBN to those captured