UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XRyfK4zKLcWJSF5kKYRc7VQ1X64967IJ129hUk+xgIA='
WHERE
key_id = 'cb0d2aabb07c2ac6929e8abe0137862c7fd43898f4401ab0bb4f18de54a8028b'
AND (
token = 'XRyfK4zKLcWJSF5kKYRc7VQ1X64967IJ129hUk+xgIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)