Fix race condition when syncing from openfn while deploy actions are running

[midigofrank]

Validation Steps

In order to test this properly, your github project should have more than 1 connection to openfn. Let's go with 2

• Trigger the deploy actions by committing and pushing to your branch then immediately go to Lightning then click sync to branch.
• You'll notice that your pull job will run 3rd, that is after the 2 deploy actions have ran.

Related issue

Fixes #2179

Review checklist

• [x] I have performed a self-review of my code
• [ ] I have verified that all appropriate authorization policies (:owner, :admin, :editor, :viewer) have been implemented and tested
• [x] If needed, I have updated the changelog
• [ ] Product has QA'd this feature

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 89.70%. Comparing base (40c8715) to head (2245451).

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #2204 +/- ## ======================================= Coverage 89.70% 89.70% ======================================= Files 275 275 Lines 9039 9039 ======================================= Hits 8108 8108 Misses 931 931 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[midigofrank]

Oops! https://taurit.pl/github-canceling-since-a-higher-priority-waiting-request-exists/

[midigofrank]

This doesn't fix the issue. It will cancel pending workflows. See: https://github.com/midigofrank/openfn/actions/runs/9542614901