In GoogleSQL you could do something like this:

UPDATE table_name
SET column = REPLACE(column, 'A-', 'A-12-')
WHERE REGEXP_CONTAINS(column, r'A-[0-9]{5}')