how to reset encrypted settings if app key changes

[ricventu]

Hi,
Thanks for your good work.
I have a question:
if APP_KEY changes, for example clone database table to another host, I cant reset encrypted values, because when I try to set the value, a 'The MAC is invalid' is raised.

for example:

$settings = app(ApiSettings::class);
$settings->api_key = '';
$settings->save();

at line $settings->api_key = ''; it try to load and decrypt api_key value before the assignment, and the DecryptException is raised

How can I clear encrypted settings without delete migrations and recreate the table?
Thanks

[ricventu]

Finally i got it

        $settingsRepository = app(SettingsRepository::class);
        $settings = app(ApiSettings::class);
        foreach ($settings::encrypted() as $key) {
            $settingsRepository->updatePropertyPayload(
                $settings::group(), $key, Crypto::encrypt('')
            );
        }

in this way its possible to clone settings table and clear out the encrypted values, without having app key