(Terminology of pseudofunctors and fibrations is mixed throughout.)
The Beck-Chevalley condition is defined on the nlab as a property of a quadruple of functors: starting from an invertible 2-cell of functors (a commutative-up-to-isomorphism square), if opposite sides have adjoints then their universal properties induces another 2-cell which we want to be invertible. For the case of bifibrations one considers commutative squares on the base and asks whether a cartesian lifting of one pair of opposite sides and a cocartesian lifting of the other opposite pair might give an invertible 2-cell.
On the other hand, another (?) thing called the Beck-Chevalley condition appears when discussing fiberwise vs fibered adjunctions. In this setting we have a morphism $F$ of fibrations over $\mathsf C$, and for the restriction $F_c$ of this morphism to each fiber we have an adjoint. The universal properties of Cartesian arrows and the adjoints again induce a 2-cell $F_cf^\ast\Rightarrow f^\star F_{c^\prime}$ which we want to be invertible.
The second Beck-Chevalley condition codifies "preservation of structure" of the adjunctions by the base-change functors, as exemplified by the fibered adjunction defining limits of a certain shape in a fibration. However, I don't really understand the first morally (though the example of bundles for monadic descent is instructive).
Are these two Beck-Chevalley conditions related somehow? Are they both special cases of a more general one? I ask because the second 2-cell does not seem to "come" from a commutative square in the base category.
Added. The prototype situation seems involve a pair of fibrations $\varphi,\psi$ over the same base, and a pair of adjunctions $$\varphi ^{-1}(a)\begin{smallmatrix} \overset{F}\rightarrow \\ \perp \\ \underset{G}\leftarrow \end{smallmatrix}\psi ^{-1}(b),\; \; \varphi^{-1}(c)\begin{smallmatrix} \overset{F^\prime}\rightarrow \\ \perp \\ \underset{G^\prime}\leftarrow \end{smallmatrix}\psi ^{-1}(d)$$ related by base-change functors $$f^\ast :\varphi^{-1}(c)\to \varphi^{-1}(a),\; \; g^\star:\psi^{-1}(d)\to \psi^{-1}(b).$$
My problem is that I can't find a general mechanism furnishing some canonical 2-cell $$F \circ f^\ast\Rightarrow g^\star \circ F^\prime$$ which encompasses both of the examples below.
There's a bifibration $\varphi$ and a commutative square $k\circ f=g\circ h$ in the base; we consider the adjunctions induced by $k,h$ related by the inverse-image functors $f^\ast ,g^\ast$. Here the 2-cell $h_!\circ f^\ast \Rightarrow g^\ast \circ k_!$ comes from the invertible 2-cell of inverse-image functors furnished by pseudofunctoriality.
There are fibrations $\varphi,\psi$ over a common base and adjunctions over fibers of the same object such that both $G,G^\prime$ come from a fibered functor $\varphi \leftarrow \psi$ $$\varphi ^{-1}(a)\begin{smallmatrix} \overset{F}\rightarrow \\ \perp \\ \underset{G}\leftarrow \end{smallmatrix}\psi ^{-1}(a),\; \; \varphi^{-1}(b)\begin{smallmatrix} \overset{F^\prime}\rightarrow \\ \perp \\ \underset{G^\prime}\leftarrow \end{smallmatrix}\psi ^{-1}(b)$$ and these are connected by the base-change functors induced by the same arrow $f$ in the base. In this case, the fibered functor preserves cartesian arrows and this induces an invertible 2-cell of the $G,G^\prime$ which, by pasting with the unit and counit, gives a 2-cell involving the fiberwise left adjoints.
Particularly, the first example is "local" and the 2-cell comes from a commutative diagram in the base, while in the other one a very global creature - a fibered functor between the fibrations - is needed to induce a 2-cell.