the issue with the solution given by @jperformance is that ACF fields are not required to be unique. It will only work if the field name that you want to change is unique. And you also need to change another meta key that holds the field key reference
"_{$old_field_name}" to ‘"_{$new_field_name}" ‘
