You would need to do a WP query to get all the posts with that value, see this https://www.advancedcustomfields.com/resources/query-posts-custom-fields/
loop over the posts and then use update_field() to update a value in another field of that post inside the loop.