UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gXKbrIn4vyjsKsePQcPdbt08O83LASqV/7Yj3MWieXw='
WHERE
key_id = 'a65d73b8168640417ed26b2a7d88360ca2be9daaf5fd28b8a7312bf339f2adf9'
AND (
token = 'gXKbrIn4vyjsKsePQcPdbt08O83LASqV/7Yj3MWieXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)