UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZGtvpqW9MVeCoBndmfSIqs2XHm/U2pZ3rgnA4KD/Bkg='
WHERE
key_id = '162d7d33793d00b62b94ed8119217b107c07e94d85054965e603dad864536acf'
AND (
token = 'ZGtvpqW9MVeCoBndmfSIqs2XHm/U2pZ3rgnA4KD/Bkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)