fix: reduce number of iops on postgresql engines

[lunar-smh]

Optimise SQL update to avoid redundant writes, which may lead to a high number of iops on postgresql engines.
This change will not change the behaviour of the code. It is only an optimisation of the update, so Postgresql does not need to spend unneccessary resources on vaccuming. I assume that the actual update is going to perform slightly better as well.

fixes #3137

Related issue(s)

Checklist

• I have read the contributing guidelines.
• I have referenced an issue containing the design document if my change
  introduces a new feature.
• I am following the
  contributing code guidelines.
• I have read the security policy. Yes, I have read this one: SECURITY.md
• I confirm that this pull request does not address a security
  vulnerability. If this pull request addresses a security vulnerability, I
  confirm that I got the approval (please contact
  security@ory.sh) from the maintainers to push
  the changes.
• I have added tests that prove my fix is effective or that my feature
  works.
• I have added or changed the documentation.

Further Comments

[codecov]

Codecov Report

Merging #3289 (ae94fba) into master (8b8e73d) will decrease coverage by 1.51%.
The diff coverage is 100.00%.

@@            Coverage Diff             @@
##           master    #3289      +/-   ##
==========================================
- Coverage   78.42%   76.91%   -1.52%     
==========================================
  Files         123      123              
  Lines       12518     8918    -3600     
==========================================
- Hits         9817     6859    -2958     
+ Misses       2061     1631     -430     
+ Partials      640      428     -212     

Impacted Files	Coverage Δ
persistence/sql/persister_oauth2.go	82.12% <100.00%> (-5.51%)	⬇️
consent/subject_identifier_algorithm_pairwise.go	37.50% <0.00%> (-14.89%)	⬇️
jwk/cast.go	61.90% <0.00%> (-13.86%)	⬇️
x/secret.go	80.00% <0.00%> (-13.75%)	⬇️
driver/registry.go	24.24% <0.00%> (-12.35%)	⬇️
cmd/version.go	44.44% <0.00%> (-10.11%)	⬇️
spec/config.go	40.00% <0.00%> (-10.00%)	⬇️
jwk/jwt_strategy.go	56.66% <0.00%> (-10.00%)	⬇️
cmd/cmd_import_jwk.go	67.53% <0.00%> (-8.40%)	⬇️
driver/config/tls.go	85.71% <0.00%> (-7.91%)	⬇️
... and 114 more

Help us with your feedback. Take ten seconds to tell us how you rate us. Have a feature suggestion? Share it here.

[lunar-smh]

I do not understand why Codecov thinks that my change will reduce coverage by 1,51%
Any help to understand the feedback and how to handle it, is much appreciated.

[aeneasr]

Nice find!

[lunar-smh]

@aeneasr Thank you for reviewing and accepting my PR.
Do you have idea when it might be released?

[aeneasr]

We will release Hydra 2.0 at the summit

[vinckr]

Hello @lunar-smh
Congrats on merging your first PR in Ory 🎉 !
Your contribution will soon be helping secure millions of identities around the globe 🌏.
As a small token of appreciation we send all our first time contributors a gift package to welcome them to the community.
Please drop me an email and I will forward you the form to claim your Ory swag!