UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NjJng1NLUE0shk8Yrl0YLUEJqllsOqe9tSkuNqnurLs=' 
WHERE 
  key_id = '1b26e43d5c08ddc8a2229071884bb90110cfacfee80657dc0e0fe905ad19ca71' 
  AND (
    token = 'NjJng1NLUE0shk8Yrl0YLUEJqllsOqe9tSkuNqnurLs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039